Access2Web version 1.2 comes with new data formatting features. This way you can display your data in various ways on your HTML pages.

This format parameter works like this:

Formatting Time data type:
<§ MyTime format(Long Time) §> displays 5:34:23 PM, system-defined long time format
<§ MyTime format(Medium time) §> displays 5:34 PM, system-defined medium time format
<§ MyTime format(Short time) §> displays 5:34, system-defined short time format
<§ MyTime format(h:m:s) §> displays 17:4:23
<§ MyTime format(hh:mm:ss) §> displays 05:04:23 PM


Formatting Date data type:
<§ MyDate format(Long Date) §> displays Sunday, June 19, 1994, system-defined long date format
<§ MyDate format(Medium Date) §> displays 19-Jun-94, system-defined medium date format
<§ MyDate format(Short Date) §> displays 19-06-94, system-defined short date format
<§ MyDate format(dddd, mmm d yyyy) §> displays Sunday, Jun 19 1994
<§ MyDate format(dd mm yy) §> displays 19-06-99


Formatting Number data type (#=optonal, 0=required):
<§ MyNumber format(##,##0.00) §> displays 5,459.00 or 0.12
<§ MyNumber format(##0.00) §> displays 5459.00 or 0.12
<§ MyNumber format(0.00%) §> displays 125.00%


Formatting Text type:
<§ MyText format(>) §> displays MyText in uppercase "HELLO"
<§ MyText format(<) §> displays MyText in lowercase "hello"

Replace tag:

<§ [Field] replace (cr,<br>) §>

The replace tag can be used to replace linebreaks in the database with the HTML equivalent <br>.